Creating an Excel Template

Export the data in a crosstabulation grid to an Excel spreadsheet by configuring the grid's Excel Settings. You can choose to export the data to a blank spreadsheet or use a predefined template, in which you can specify the start point for the data.

You can also create additional start points to export multiple grids to the same spreadsheet. When exporting multiple grids at the same time, the grids will be displayed beneath each other in the same worksheet.

Procedure

1. Open Excel and create a new spreadsheet that includes the required set of styles, such as headings and colors.
2. Select the position of the start point, that is the cell where the first field of exported grid data will be displayed.
3. Select the Formulas tab then click the Name Manager button

The Name Manager window is displayed.

4. Click the New button.

The New Name window is displayed.

5. Enter a name for the start point.
6. Click OK.

The start point is added to the Name Manager tab.

7. Click Close.
8. If you want to export multiple grids to the same spreadsheet, create a new start point for each grid by repeating steps 2 to 7. New start points can be created in any worksheet, and you can have multiple start points in the same sheet.
9. If you want to export multiple grids to the same spreadsheet, create a new start point for each grid by repeating steps 2 to 7. New start points can be created in any worksheet, and you can have multiple start points in the same sheet.

• Crosstab Grid
  • Defining a Crosstab Grid
  • Grid Presentation Settings
  • Saving a Grid as a Template
  • Template Toolbar
  • Creating an Excel Template
  • Exporting to Excel